# coding:utf-8
# name ：YuFuXiao
# date : 2018-9-XX
from sqlalchemy import Column, Integer, String, Text

from app.models.base import db


class Book(db.Model):
    id = Column(Integer,primary_key=True)  #Column:列
    title = Column(String(64),nullable=False)
    author = Column(String(32),default='未知')
    binding = Column(String(20))  #装帧版本
    publisher = Column(String(20)) #出版社
    price = Column(String(20))    #价格
    pages = Column(Integer)
    pubdate = Column(String(20)) #出版日期
    isbn = Column(String(15),nullable=False,unique=True)
    summary = Column(Text(1000))  #简介 Text：长文本
    image = Column(String(10))















































































































